// 配送车辆
const {DataTypes, db } = require("../db");
db.define('cars', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:'租户ID'}, 
licence:{type: DataTypes.STRING(50),allowNull:false,comment:'车牌号'}, 
name:{type: DataTypes.STRING(50),comment:'车辆描述,名称'}, 
load:{type: DataTypes.DECIMAL(10, 2),defaultValue:0,comment:'车载重'}, 
disabled:{type: DataTypes.INTEGER,defaultValue:0,comment:'停用'}, 
isDelete:{type: DataTypes.INTEGER,defaultValue:0,comment:'删除'}, 
createdAt:{type: DataTypes.STRING(20),comment:'创建时间'}, 
length:{type: DataTypes.INTEGER,defaultValue:0,comment:'长'}, 
width:{type: DataTypes.INTEGER,defaultValue:0,comment:'宽'}, 
height:{type: DataTypes.INTEGER,defaultValue:0,comment:'高'}, 
cby:{type: DataTypes.INTEGER,comment:''}, 
ctime:{type: DataTypes.STRING(20),comment:''}, 
uby:{type: DataTypes.INTEGER,comment:''}, 
utime:{type: DataTypes.STRING(20),comment:''}, 
isDel:{type: DataTypes.INTEGER,defaultValue:0,comment:''}, 
dby:{type: DataTypes.INTEGER,comment:''}, 
dtime:{type: DataTypes.STRING(20),comment:''}, 

}, {
    tableName: 'cars',
    timestamps: false,
    comment: '配送车辆',

});